﻿using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class Student_Default2 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        SqlDataSource1.SelectCommand = "SELECT t_paper.name AS paperName, t_student.name AS studentNamw, t_exam.date, t_exam.score, t_exam.usedMinutes FROM t_exam  INNER JOIN t_student ON t_exam.stuId = t_student.id and t_exam.stuId='" + Session["id"] + "' INNER JOIN t_paper ON t_exam.paperId = t_paper.id";

        //and t_exam.stuId='" + Session["id"] + "'
        //msg.Text = "SELECT t_paper.name AS paperName, t_student.name AS studentNamw, t_exam.date, t_exam.score, t_exam.usedMinutes FROM t_exam  INNER JOIN t_student ON t_exam.stuId = t_student.id and t_exam.stuId='" + Session["id"] + "' INNER JOIN t_paper ON t_exam.paperId = t_paper.id";
    }
}
